------------------------------------------------------------------------------------
--    TABLE NAME : dbo.TableChangeLog
--   DESCRIPTION : TableDescriptionAndPurposeGoesHere
------------------------------------------------------------------------------------
--  POPULATED BY : Triggers
--  DAYS TO KEEP : Infinite
--   MAINTENANCE : Self cleaning process ....
------------------------------------------------------------------------------------
-- CHANGE HISTORY:
-- DATE        MODIFIED   DESCRIPTION   
------------------------------------------------------------------------------------
-- 08.04.2010  SYoung     Initial creation
------------------------------------------------------------------------------------
CREATE TABLE [dbo].[TableChangeLog](
       [TableChangeLogID] [int] IDENTITY(1,1) NOT NULL,
       [ExecutedAction] [char](1) NOT NULL,
       [TableName] [varchar](128) NOT NULL,
       [PK] [varchar](1000) NOT NULL,
       [FieldName] [varchar](128) NOT NULL,
       [OldValue] [varchar](1000) NULL,
       [NewValue] [varchar](1000) NULL,
       [UpdateDate] [datetime] NOT NULL,
       [UserName] [varchar](128) NULL,
       [ExecutedFrom] [varchar](128) NULL,
CONSTRAINT [PK_TableChangeLog_1] PRIMARY KEY CLUSTERED (
       [TableChangeLogID] ASC)
)
GO
